Edinburgh’s road network

Edinburgh’s implementation zones

Edinburgh’s control zones

Time series analysis

Mapping accidents with roads: 2013/2014

##                    LAYER Accident_Index
## 1 20mph existing streets            142
## 2    20mph local streets            146
## 3     20mph main streets            400
## 4                  30mph            280
## 5        Part time 20mph              7
## 6            Trunk roads              3

Mapping accidents with roads: 2014/2015

##                    LAYER Accident_Index
## 1 20mph existing streets            102
## 2    20mph local streets            134
## 3     20mph main streets            391
## 4                  30mph            251
## 5        Part time 20mph              7
## 6            Trunk roads              5

Mapping accidents with roads: 2015/2016

##                    LAYER Accident_Index
## 1 20mph existing streets            112
## 2    20mph local streets            146
## 3     20mph main streets            359
## 4                  30mph            277
## 5        Part time 20mph              6
## 6            Trunk roads              3

Mapping accidents with roads: 2018/2019

##                    LAYER Accident_Index
## 1 20mph existing streets            129
## 2    20mph local streets            166
## 3     20mph main streets            385
## 4                  30mph            319
## 5        Part time 20mph             10

Count pre 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            356
## 2    20mph local streets            426
## 3     20mph main streets           1150
## 4                  30mph            808
## 5        Part time 20mph             20
## 6            Trunk roads             11

Count post 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            129
## 2    20mph local streets            166
## 3     20mph main streets            385
## 4                  30mph            319
## 5        Part time 20mph             10

Output column: Layer

##   Accident_Index                  LAYER
## 1  2015950002854 20mph existing streets
## 2  2014950005401 20mph existing streets
## 3  2014950003046 20mph existing streets
## 4  2014950001765 20mph existing streets
## 5  2016950000527 20mph existing streets
## 6  2016950002264 20mph existing streets

Table: Average annual road traffic collision rates in the city of Edinburgh

Table 1: Average annual road traffic collision rates in the city of Edinburgh (council data)
collisions pre-20mph ( 2013 / 2016 - 3 years ) collisions post-20mph ( 2018 / 2019 - 22 months ) rate pre-20mph rate post-20mph diff in rates = pre - post Perc.diff.rates = (pre - post) / pre * 100
Streets stayed
at 30mph 819 319 273.00 174.32 98.68 36
at 20mph 356 129 118.67 70.49 48.18 41
Part time 20mph : a traffic calming measure in specific hours per day. e.g outside of schools, at the start and end of the school day 20 10 6.67 5.46 1.21 18
Streets changed
at 30mph changed to 20mph 1576 551 525.33 301.09 224.24 43
All streets
All streets 2771 1009 923.67 551.37 372.30 40
Note:
1 All accidents at 20mph, 30mph

Effect estimate

Total number of collisions in the city of Edinburgh
Tax year 2013/14 2014/15 2015/16 2016/17 2017/18 2018/19 2019/20
Annual number of collisions 978 890 903 Intervention years 581 428
Rate per year 978 890 903 581 515.66
% reduction in collisions 36.54
Calculations
A + B + C / 3 923.67
D + E / 1.83 551.37
A - B / A 9.00
B - C / B -1.00
Unadjusted_estimate 40.00
Secular_trend 4.00
Note:
1 A : accidents 2013/14 ( 1 year )
2 B : accidents 2014/15 ( 1 year )
3 C : accidents 2015/16 ( 1 year )
4 D : accidents 2018/19 ( 1 year )
5 E : accidents 2019/20 ( 10 months )

Mapping accidents with implementation zones : 2013

Mapping accidents with implementation zones: 2014

Mapping accidents with implementation zones: 2015

Mapping accidents with implementation zones: 2016

Mapping accidents with implementation zones: 2017

Mapping accidents with implementation zones: 2018

Output column: Implementation Zone

##   Accident_Index ImplementationZone
## 1  2016950000001                  2
## 2  2016950000003                  2
## 3  2016950000004                  2
## 4  2016950000007                  1
## 5  2016950000047                  3
## 6  2016950000111                  3

Table: Average annual road traffic collision rates in the city of Edinburgh per implementation zone

Table 3: Average annual road traffic collision rates in the city of Edinburgh per implementation zone
Implementation zone collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
1a 472 315 157.33 121.15 36.18 23
1b 71 55 23.67 21.15 2.52 11
2 674 261 224.67 130.50 94.17 42
3 842 380 280.67 190.00 90.67 32
4 181 68 60.33 45.33 15.00 25
5 275 76 91.67 50.67 41.00 45
6 210 34 70.00 37.78 32.22 46
All zones 2725 928 908.33 356.92 551.41 61

Control zone 1a:City center –> George St/Harbour, Aberdeen

## [1] 70

Control zone 1b:Rural west –> Tay Bridgehead & St Andrews

## [1] 43

Control zone 3:South central –> Dundee

## [1] 280

Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West

## [1] 141

Control zone 5:West –> Glasgow Kelvin

## [1] 508

Control zone 6:South –> Paisley

## [1] 165

Updated dataset for Edinburgh

##   Accident_Index Control_zone
## 1  2013921302856           1a
## 2  2013921303288           1a
## 3  2013921303410           1a
## 4  2013921303560           1a
## 5  2013921303685           1a
## 6  2013921303761           1a
##   Accident_Index LAYER ImplementationZone Control_zone DataZone Name
## 1  2016950000001  <NA>                  2         <NA>     <NA> <NA>
## 2  2016950000003  <NA>                  2         <NA>     <NA> <NA>
## 3  2016950000004  <NA>                  2         <NA>     <NA> <NA>
## 4  2016950000007  <NA>                  1         <NA>     <NA> <NA>
## 5  2016950000047  <NA>                  3         <NA>     <NA> <NA>
## 6  2016950000111  <NA>                  3         <NA>     <NA> <NA>